home *** CD-ROM | disk | FTP | other *** search
-
- Problem Five year projection of start-up companies financial statements.
- Several key management decisions are defined in the Assumptions
- sections thereby maximizing their ability to do what-if analysis
- in these key areas.
-
- Block Diagram
- _______________________________________________
- | | | |
- | Global | | |
- | Assumptions | | |
- | - Yearly | | Macros |
- |-------------| | |
- | Global | | |
- | Assumptions | | |
- | - Monthly | | |
- |-------------|----------|----------|----------|---------|
- Income | 1st Year | 1st Year | 2nd Year | 3rd Year | 5 Yrs |
- Statements | Monthly | Qtrly | Qtrly | Qtrly | Annually|
- |-------------|----------|----------|----------|---------|
- Cash Flow | 1st Year | 1st Year | 2nd Year | 3rd Year | 5 Yrs |
- Projections | Monthly | Qtrly | Qtrly | Qtrly | Annually|
- |-------------|----------|----------|----------|---------|
- Balance | 1st Year | 1st Year | 2nd Year | 3rd Year | 5 Yrs |
- Sheets | Monthly | Qtrly | Qtrly | Qtrly | Annually|
- |-------------|----------|----------|----------|---------|
- Ratio | 1st Year | 1st Year | 2nd Year | 3rd Year | 5 Yrs |
- Analysis | Monthly | Qtrly | Qtrly | Qtrly | Annually|
- |-------------|----------|----------|----------|---------|
-
- Tips Bounce macros (AR9) Print macros (AH1)
- \7 macro name - execute by pressing F7 key twice
- View various graphs with {menu} Graph 1st-settings Name Use CMD
- Out of balance check on balance sheet (A183)
- Use of split window for entering formulas - press ZOOM key.
- Remember that WINDOW key works when entering formulas.
-
-